Macro - To create one [.csv] file from/using multiple workbooks, kept in a folder, containing multi
Posted
by AJ
on Stack Overflow
See other posts from Stack Overflow
or by AJ
Published on 2010-05-04T15:02:45Z
Indexed on
2010/05/05
14:18 UTC
Read the original article
Hit count: 187
excel-vba
Hello,
I have more than one Excel Workbooks containing multiple worksheets in each of them.
I would like to have a macro which help me to create (combine the information from) all the worksheets into one pipe [|] delimited [.csv] file.
These sheets should be combined/appended into the [.csv] file, in the same order these worksbooks appear in a folder and in the order sheets appear in these workbooks.
The macro should ask for a delimiter/separator specific to me and the input and output path based on my selection.
It would be great if the output [.csv] file is names as "foldername" + "Output.csv"
Thank you,
Best Regards - AJ
© Stack Overflow or respective owner